if exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_OrderProduct') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_OrderProduct
END
GO
	CREATE VIEW V_OrderProduct
	AS 
	SELECT 
	A.Guid,A.OrderInfoGuid,A.ProductGuid,
	A.Attributes,A.ExtensionAttriutes,
	A.NAME,A.BuyNumber,A.BuyPrice,A.IsShipment,
	A.IsJoinActivity,A.IsPresent
	FROM ShopNum1_OrderProduct A 